Module 5 - Using Databases
      The Database Software tutorial takes you through tasks in Access 2010 as per module 5 of the ECDL syllabus 5.      
      Starting Access and Help      
      Upon successful completion you will be able to:

1. Understand what Databases are;
2. Start Access 2010;
3. Use Access 2010 Help;
4. Use Help Tools;
5. Use the Search Pane;
6. Use the Table of Contents;
6. Quit Access 2010.		      
      Opening Existing Databases      
      Upon successful completion you will be able to:

1. Open Existing Database Objects;
2. Use the Open Box;
3. Navigate to Drives and Folders;
4. Change Views;
5. Move Between Database Objects;
6. Close Database Objects;
7. Connect to SQL Server;
8. Close Databases;
9. Quit Access.		      
      Table Basics      
      Upon successful completion you will be able to:

1. Create New Tables;
2. Add Fields to a Table;
3. Set a Primary Key;
4. View and Set Field Properties;
5. Add Extra Table Fields;
6. Add New Records;
7. Modify and Delete Record Data;
8. Navigate around Tables;
9. Delete Tables.		      
      Creating and Using Forms      
      Upon successful completion you will be able to:

1. Open Existing Forms;
2. Create New Forms;
3. Add Fields to Forms;
4. Choose the Form Layout and Style;
5. Navigate within Forms;
6. Add New Records to Forms;
7. Enter and Edit Data in Forms;
8. Delete Records in Forms;
9. View Table Data.		      
      Finding and Filtering Data      
      Upon successful completion you will be able to:

1. Find Text in Records;
2. Find Numbers in Records;
3. Find Dates in Records;
4. Use Filters;
5. Remove Filters;
6. Use Filter By Form;
7. Close Forms.		      
      Creating Reports      
      Upon successful completion you will be able to:

1. Generate Reports;
2. Add Fields to Reports;
3. Group Report Records;
4. Use Sort and Summary Options;
5. Use Title and Display Options;
6. Create Automatic Reports;
7. Save and Close Reports;
8. Delete Reports.		      
      Screen Components      
      Upon successful completion you will be able to:

1. Identify Windows Objects;
2. Display Database Objects;
3. Open Database Objects;
4. Open Backstage View;
5. Understand the Ribbon;
6. Use Dialog Box Launchers;
7. Understand Contextual Tabs;
8. Modify the Quick Access Toolbar.		      
      Creating Databases      
      Upon successful completion you will be able to:

1. Create a Database from a Template;
2. Save a New Database to a New Folder;
3. Enter Data into Tables;
4. Delete a Database.		      
      Table Design      
      Upon successful completion you will be able to:

1. Change Field Names;
2. Change Field Properties;
3. Set Validation Rules;
4. Index Fields;
5. Set Primary Key Fields;
6. Modify Field Positions;
7. Save Design Changes;
8. Modify Column Widths.		      
      Modifying Forms      
      Upon successful completion you will be able to:

1. Modify Sections in Forms;
2. Work with Controls in Forms;
3. Change Label Names;
4. Modify the Tab Order;
5. Save and Close Forms;
6. Delete Forms.		      
      Creating Basic Queries      
      Upon successful completion you will be able to:

1. Create New Queries;
2. Add and Remove Fields in Queries;
3. Show and Hide Fields;
4. Sort in a Query;
5. Run Queries;
6. Save Queries;
7. Close and Delete Queries.		      
      Modifying Reports      
      Upon successful completion you will be able to:

1. Work with Layouts;
2. Move Controls;
3. Edit and Format Labels;
4. Use Numeric Formatting;
5. Use Headers and Footers;
6. Preview Reports;
7. Insert Graphics;
8. Save Report Changes;
9. Add and Remove Headers and Footers.		      
      Database Basics      
      Upon successful completion you will be able to:

1. Open Database Objects;
2. Comprehend Tables;
3. Identify Primary Key Fields;
4. Index Fields;
5. Understand Table Relationships;
6. Understand Referential Integrity;
7. Comprehend Queries;
8. Understand Forms and Reports;
9. Use Different Report Views.		      
      Multiple Table Queries      
      Upon successful completion you will be able to:

1. Use Multiple Table Queries;
2. Join Tables in a Query;
3. Add Selection Criteria;
4. Use Logical Operators;
5. Delete Existing Criteria;
6. Understand Or and Like Operators;
7. Use Wildcards.		      
      Previewing and Printing      
      Upon successful completion you will be able to:

1. Preview Datasheets;
2. Print Datasheets;
3. Preview Reports;
4. Change the Page Setup;
5. Print Reports;
6. Print Query Output;
7. Print Forms.		      
      Sorting Records      
      Upon successful completion you will be able to:

1. Sort Data;
2. Sort in Tables;
3. Sort in Queries;
4. Sort in Forms.		      
      Exporting      
      Upon successful completion you will be able to:

1. Export Database Objects;
2. Export Tables in Other Formats;
3. Save Exported Files;
4. Export Query Output in Other Formats;
5. Open Exported Files.		      
This course can be purchased either individaully or as part of a package.
Single Training Course - Module 5 - Using Databases :
Office Suite Training Courses - ECDL - Office 2010 (Europe) :
© 2015 Online Training Masters